<!DOCTYPE html>
<html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-0 vector-toc-not-available vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-0 vector-feature-night-mode-enabled skin-theme-clientpref-os vector-sticky-header-enabled" lang="fr" dir="ltr"><head>
<meta charset="UTF-8">
<title>SQLAlchemy</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="icon" type="image/png" href="./_res_/favicon.png">
<link rel="canonical" href="https://fr.wikipedia.org/wiki/SQLAlchemy"> <link href="./_mw_/ext.cite.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.wikimediamessages.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.icons.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.search.codex.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.styles.css" rel="stylesheet" type="text/css">
<meta name="ResourceLoaderDynamicStyles" content="">
<link rel="stylesheet" type="text/css" href="./_mw_/site.styles.css">
<link rel="stylesheet" type="text/css" href="./_mw_/noscript.css">
<link rel="stylesheet" type="text/css" href="./_res_/footer.css">
<link rel="stylesheet" type="text/css" href="./_res_/vector-2022.css">
</head>
<body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-SQLAlchemy rootpage-SQLAlchemy skin-vector-2022 action-view">
<div class="mw-page-container">
<div class="mw-page-container-inner">
<div class="mw-content-container">
<main id="content" class="mw-body">
<header class="mw-body-header vector-page-titlebar">
<h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-main">SQLAlchemy</span></h1>
</header>
<a id="top"></a>
<div id="bodyContent" class="vector-body ve-init-mw-desktopArticleTarget-targetContainer" aria-labelledby="firstHeading" data-mw-ve-target-container="">
<div id="contentSub">
<div id="mw-content-subtitle"></div>
</div>
<div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="fr" dir="ltr"><div class="mw-content-ltr mw-parser-output" lang="fr" dir="ltr"><div class="infobox_v3 infobox infobox--frwiki noarchive" style="width:260px">
<div class="entete icon informatique" style="color: #000000;"><style data-mw-deduplicate="TemplateStyles:r228712691">
/* start https://fr.wikipedia.org/ */
.mw-parser-output .entete.informatique{background-image:url("./_mw_/Picto.nfo.png")}
/* end https://fr.wikipedia.org/ */
</style>
<div>SQLAlchemy</div>
</div>
<p class="mw-empty-elt">
</p>
<table><caption style="color:#000000;">Informations</caption>
<tbody><tr>
<th scope="row"> <a href="Version_d'un_logiciel" title="Version d'un logiciel">Dernière version</a>
</th>
<td>
<span class="wd_p348">2.0.44 (<time class="nowrap" datetime="2025-10-10" data-sort-value="2025-10-10">10 octobre 2025</time>)<sup id="cite_ref-wikidata-85ba67212611a09eb6f46525478900f9b48f064c_1-0" class="reference"><a href="#cite_note-wikidata-85ba67212611a09eb6f46525478900f9b48f064c-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup></span></td>
</tr>
<tr>
<th scope="row"><a href="D%C3%A9p%C3%B4t_(informatique)" title="Dépôt (informatique)">Dépôt</a></th>
<td>
<span class="wd_p1324"><a rel="nofollow" class="external text" href="https://github.com/sqlalchemy/sqlalchemy">github.com/sqlalchemy/sqlalchemy</a></span></td>
</tr>
<tr>
<th scope="row"> <a href="Langage_de_programmation" title="Langage de programmation">Écrit en</a>
</th>
<td>
<span class="wd_p277"><a href="Python_(langage)" title="Python (langage)">Python</a></span></td>
</tr>
<tr>
<th scope="row"> Type
</th>
<td>
<span class="wd_p31">Interface de base de données <small>(<a href="https://www.wikidata.org/wiki/Q1172367" class="extiw external" title="d:Q1172367"><span class="indicateur-langue" title="Voir l'élément Wikidata correspondant">d</span></a>)</small><br><a href="Langage_de_requ%C3%AAte" title="Langage de requête">Langage de requête</a><br><a href="Biblioth%C3%A8que_logicielle" title="Bibliothèque logicielle">Bibliothèque logicielle</a><br>Bibliothèque logicielle Python <small>(<a href="https://www.wikidata.org/wiki/Q29642950" class="extiw external" title="d:Q29642950"><span class="indicateur-langue" title="Voir l'élément Wikidata correspondant">d</span></a>)</small></span></td>
</tr>
<tr>
<th scope="row"><a href="Licence_de_logiciel" title="Licence de logiciel">Licence</a></th>
<td>
<span class="wd_p275"><a href="Licence_MIT" title="Licence MIT">Licence MIT</a></span></td>
</tr>
<tr>
<th scope="row"><a href="Site_web" title="Site web">Site web</a></th>
<td>
<span class="wd_p856"><a rel="nofollow" class="external text" href="https://www.sqlalchemy.org/">www.sqlalchemy.org</a></span></td>
</tr>
</tbody></table>
<p class="mw-empty-elt">
</p>
</div>
<p><b>SQLAlchemy</b> est un toolkit <a href="Open_source" title="Open source">open source</a> <a href="Structured_Query_Language" title="Structured Query Language">SQL</a> et un <a href="Mapping_objet-relationnel" title="Mapping objet-relationnel">mapping objet-relationnel</a> (ORM) écrit en <a href="Python_(langage)" title="Python (langage)">Python</a> et publié sous <a href="MIT_Licence" class="mw-redirect" title="MIT Licence">licence MIT</a>.
</p><p>SQLAlchemy a opté pour l'utilisation du pattern <a href="Data_mapper" title="Data mapper">data mapper</a><sup id="cite_ref-2" class="reference"><a href="#cite_note-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> plutôt que l'<a href="Active_record_(patron_de_conception)" class="mw-redirect" title="Active record (patron de conception)">active record</a> utilisés par de nombreux autres ORM.
</p><p>SQLAlchemy a été publié en <time class="nowrap date-lien" datetime="2006-02" data-sort-value="2006-02"><a href="F%C3%A9vrier_2006" title="Février 2006">février</a> <a href="2006_en_informatique" title="2006 en informatique">2006</a></time> et est rapidement devenu l'un des ORM les plus utilisés par la communauté Python.
</p>
<div class="mw-heading mw-heading2"><h2 id="Notes_et_références"><span id="Notes_et_r.C3.A9f.C3.A9rences"></span>Notes et références</h2></div>
<div class="mw-references-wrap"><ol class="references">
<li id="cite_note-wikidata-85ba67212611a09eb6f46525478900f9b48f064c-1"><span class="mw-cite-backlink"><a href="#cite_ref-wikidata-85ba67212611a09eb6f46525478900f9b48f064c_1-0">↑</a> </span><span class="reference-text"><span class="ouvrage">« <a rel="nofollow" class="external text" href="https://github.com/sqlalchemy/sqlalchemy/releases/tag/rel_2_0_44"><cite style="font-style:normal;"><span class="lang-en" lang="en">Release 2.0.44</span></cite></a> », <time class="nowrap" datetime="2025-10-10" data-sort-value="2025-10-10">10 octobre 2025</time> <small style="line-height:1em;">(consulté le <time class="nowrap" datetime="2025-10-21" data-sort-value="2025-10-21">21 octobre 2025</time>)</small></span></span>
</li>
<li id="cite_note-2"><span class="mw-cite-backlink"><a href="#cite_ref-2">↑</a> </span><span class="reference-text"><a rel="nofollow" class="external text" href="http://www.martinfowler.com/eaaCatalog/dataMapper.html">martinfowler.com/eaaCatalog/dataMapper.html</a></span>
</li>
</ol></div>
<div class="mw-heading mw-heading2"><h2 id="Liens_externes">Liens externes</h2></div>
<ul><li><abbr class="abbr indicateur-langue" title="Langue : anglais">(en)</abbr> <a rel="nofollow" class="external free" href="http://www.sqlalchemy.org">http://www.sqlalchemy.org</a> : Site officiel</li></ul>
<ul id="bandeau-portail" class="bandeau-portail"><li><span class="bandeau-portail-element"><span class="bandeau-portail-icone"><span class="noviewer" typeof="mw:File"></span></span> <span class="bandeau-portail-texte">Portail des logiciels libres</span> </span></li> <li><span class="bandeau-portail-element"><span class="bandeau-portail-icone"><span class="noviewer" typeof="mw:File"></span></span> <span class="bandeau-portail-texte">Portail des bases de données</span> </span></li> </ul></div><!--htdig_noindex--><div><div class="zim-footer">
Cet article est issu de <a class="external text" title="Dernière modification le 2025-08-03" href="https://fr.wikipedia.org/wiki/?title=SQLAlchemy&oldid=227815030">Wikipédia</a>. Sauf mention contraire, le texte est disponible sous <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.fr">Creative Commons Attribution-Share Alike 4.0</a>. Des conditions supplémentaires peuvent s’appliquer aux fichiers multimédias.
</div>
</div><!--/htdig_noindex--></div>
</div>
</main>
</div>
</div>
</div>
<script src="./_webp_/webpHandler.js"></script>
</body></html>